Tabela ActiveIngredientGroup

Definicja tabeli ActiveIngredientGroup

Name

ActiveIngredientGroup

Code

ActiveIngredientGroup

Comment

PL:Grupy substancji czynnych ze slownika GRS


Lista kolumn tabeli ActiveIngredientGroup

Name

Code

activeIngredientGroupID

activeIngredientGroupID

dictionaryVersion

dictionaryVersion

dictionarySymbol

dictionarySymbol

dictionaryCode

dictionaryCode

code

code

name

name

measureId

measureId

active

active


Kolumna activeIngredientGroupID tabeli ActiveIngredientGroup

Definicja kolumny activeIngredientGroupID tabeli ActiveIngredientGroup

Name

activeIngredientGroupID

Code

activeIngredientGroupID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna dictionaryVersion tabeli ActiveIngredientGroup

Definicja kolumny dictionaryVersion tabeli ActiveIngredientGroup

Name

dictionaryVersion

Code

dictionaryVersion

Data Type

VARCHAR2(5)

Mandatory

No

Comment

wersja slownika


Kolumna dictionarySymbol tabeli ActiveIngredientGroup

Definicja kolumny dictionarySymbol tabeli ActiveIngredientGroup

Name

dictionarySymbol

Code

dictionarySymbol

Data Type

VARCHAR2(20)

Mandatory

No

Comment

symbol danej wersji slownika


Kolumna dictionaryCode tabeli ActiveIngredientGroup

Definicja kolumny dictionaryCode tabeli ActiveIngredientGroup

Name

dictionaryCode

Code

dictionaryCode

Data Type

VARCHAR2(6)

Mandatory

No

Comment

opis: kod slownika


Kolumna code tabeli ActiveIngredientGroup

Definicja kolumny code tabeli ActiveIngredientGroup

Name

code

Code

code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

kod grupy substancji


Kolumna name tabeli ActiveIngredientGroup

Definicja kolumny name tabeli ActiveIngredientGroup

Name

name

Code

name

Data Type

VARCHAR2(250)

Mandatory

No

Comment

nazwa grupy substancji


Kolumna measureId tabeli ActiveIngredientGroup

Definicja kolumny measureId tabeli ActiveIngredientGroup

Name

measureId

Code

measureId

Data Type

NUMBER(10)

Mandatory

No

Comment

kod jednostki miar ze slownika Drug.Measure


Kolumna active tabeli ActiveIngredientGroup

Definicja kolumny active tabeli ActiveIngredientGroup

Name

active

Code

active

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Lista kluczy tabeli ActiveIngredientGroup

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ActiveIngredientGroup

Definicja klucza Identifier_1 tabeli ActiveIngredientGroup

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment